/**
 *
 *  Copyright (c) 2011, AstroDAbis
 *  All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without modification,
 *  are permitted provided that the following conditions are met:
 *
 *      * Redistributions of source code must retain the above copyright notice,
 *        this list of conditions and the following disclaimer.
 *      * Redistributions in binary form must reproduce the above copyright notice,
 *        this list of conditions and the following disclaimer in the documentation
 *        and/or other materials provided with the distribution.
 *
 *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
 *  ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
 *  WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
 *  IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
 *  INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
 *  BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 *  DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
 *  LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
 *  OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
 *  OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 */
package org.jiscinvolve.astrodabis.mallow.control.joins;

import java.io.File;
import java.io.InputStream;
import java.io.IOException;

import java.util.Iterator;

import java.util.Date;
import java.text.DateFormat;
import java.text.SimpleDateFormat;

import javax.validation.Valid;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import org.springframework.stereotype.Controller;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.context.request.WebRequest;

import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ModelAttribute;

import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional; 

import org.springframework.validation.FieldError;
import org.springframework.validation.ObjectError;
import org.springframework.validation.BindingResult;

import org.jiscinvolve.astrodabis.mallow.model.api.Account;
import org.jiscinvolve.astrodabis.mallow.model.jpa.DuplicateEntryException;

import org.jiscinvolve.astrodabis.mallow.model.api.JoinTag;
import org.jiscinvolve.astrodabis.mallow.model.api.JoinTagFactory;
import org.jiscinvolve.astrodabis.mallow.impl.model.vot.SimpleVOTableJoinTagParser;

import org.jiscinvolve.astrodabis.mallow.impl.model.jpa.PersistentManagerImpl;

import org.jiscinvolve.astrodabis.mallow.control.ViewData;
import org.jiscinvolve.astrodabis.mallow.control.DataIter;
import org.jiscinvolve.astrodabis.mallow.control.BaseController;
import org.jiscinvolve.astrodabis.mallow.control.NotFoundException;
import org.jiscinvolve.astrodabis.mallow.control.PermissionException;

/**
 * Upload data to the server. 
 *
 */
@Controller
@RequestMapping("/join/test")
public class SimpleJoinController
extends BaseController
    {

    /**
     * Our debug logger.
     * 
     */
    private static Log log = LogFactory.getLog(SimpleJoinController.class);

    /**
     * The form view (JSP) path.
     * 
     */
    public static final String FORM_VIEW = "joins/simple-join-form" ;

    /**
     * The done view (JSP) path.
     * 
     */
    public static final String DONE_VIEW = "joins/simple-join-done" ;

    /**
     * The form data (bean) attribute name.
     * 
     */
    public static final String FORM_DATA = "bean" ;

    /**
     * Create the SimpleJoinData for this request.
     *
     */
    @ModelAttribute(ViewData.VIEW_DATA)
    public SimpleJoinData data(
        WebRequest request
        ){
        return new SimpleJoinData(
            request,
            this.actor(
                request
                )
            );
        }

    /**
     * Get the form.
     * 
     */
	@RequestMapping(method=RequestMethod.GET)
	public ModelAndView page(
	    @ModelAttribute(ViewData.VIEW_DATA) SimpleJoinData data,
	    ModelAndView model
	    ){
        log.debug("SimpleJoinController.page(....)");
        //
        // Check we are logged in.
        if (data.actor() == null)
            {
            throw new PermissionException();
            }
        //
        // Add an empty bean to our model.
        model.addObject(
            FORM_DATA,
            new SimpleJoinBean()
            );
        model.setViewName(
		    FORM_VIEW
            );
        return model;
        }

    /**
     * Post the form.
     * 
     */
	@RequestMapping(method=RequestMethod.POST)
	public String post(
	    @ModelAttribute(FORM_DATA) @Valid SimpleJoinBean bean, BindingResult result,
	    @ModelAttribute(ViewData.VIEW_DATA) SimpleJoinData data,
	    ModelAndView model
	    ){
        log.debug("SimpleJoinController.post(....)");
        //
        // Check we are logged in.
        if (data.actor() == null)
            {
    		return data.redirect();
    		}
        //
        // If the input is not valid, re-display the form page.
	    if (result.hasErrors())
	        {
    		return FORM_VIEW ;
	        }
        //
        // Add the uploaded file data to our model.
        try {
            //
            // Check for null table.
            if ("-".equals(bean.getLeft()))
                {
                result.addError(
                    new FieldError(
                        FORM_DATA,
                        "left",
                        "Please select a table"
                        )
                    );
        		return FORM_VIEW ;
                }
            else if ("-".equals(bean.getRight()))
                {
                result.addError(
                    new FieldError(
                        FORM_DATA,
                        "right",
                        "Please select a table"
                        )
                    );
        		return FORM_VIEW ;
                }
            //
            // Create the JoinTagFactory and setup the callback iterator.
            else {

                data.factory(
                    create(
                        bean,
                        data
                        )
                    );

                data.iterator(
                    new DataIter()
                        {
                        public void iterate(Iterator iter)
                            {
PersistentManagerImpl.instance().process(iter);
                            }
                        }

                    );

                return DONE_VIEW ;
                }
            }
        //
        // Anything goes wrong, add an error and re-display the form page.
        catch (Throwable ouch)
            {
            log.error("Exception while processing data [" + ouch.getClass().getName() + "][" + ouch.getMessage() + "]");
            result.addError(
                new ObjectError(
                    FORM_DATA,
                    "Operation failed due to technical problems, please try again later"
                    )
                );
    		return FORM_VIEW ;
            }
        }

/*
 * http://static.springsource.org/spring/docs/3.0.x/javadoc-api/org/springframework/web/multipart/commons/CommonsMultipartFile.html
 * CommonsMultipartFile
 * public void transferTo(File dest)
 * File temp = File.createTempFile("temp-file-name", ".tmp"); 
 *
 */

    /**
     * Create the JoinTagFactory.
     *
     */
    @Transactional(readOnly=true)
    protected JoinTagFactory create(SimpleJoinBean bean, SimpleJoinData data)
    throws IOException
        {
        return new JoinTagFactory(
            data.actor(),
            new SimpleVOTableJoinTagParser(
                this.table(
                    bean.getLeft()
                    ),
                this.table(
                    bean.getRight()
                    ),
                bean.getFile().getInputStream()
                )
            );
        }

    /**
     * Iterate a JoinTag Iterator inside a database transaction.
     *
    @Transactional(readOnly=false, propagation=Propagation.REQUIRES_NEW)
    public void process(Iterator<JoinTag> iter)
        {
        log.debug("SimpleJoinController.process().start");
        while (iter.hasNext())
            {
            log.debug("SimpleJoinController.process().next");
            JoinTag jtag = iter.next();
            //log.debug("JoinTag [" + jtag.ident() + "]");
            }
        log.debug("SimpleJoinController.process().done");
        }
     */

    }

